<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `ecm_order`;");
E_C("CREATE TABLE `ecm_order` (
  `order_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `order_sn` varchar(20) NOT NULL DEFAULT '',
  `type` varchar(10) NOT NULL DEFAULT 'material',
  `extension` varchar(10) NOT NULL DEFAULT '',
  `seller_id` int(10) unsigned NOT NULL DEFAULT '0',
  `seller_name` varchar(100) DEFAULT NULL,
  `buyer_id` int(10) unsigned NOT NULL DEFAULT '0',
  `buyer_name` varchar(100) DEFAULT NULL,
  `buyer_email` varchar(60) NOT NULL DEFAULT '',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `add_time` int(10) unsigned NOT NULL DEFAULT '0',
  `payment_id` int(10) unsigned DEFAULT NULL,
  `payment_name` varchar(100) DEFAULT NULL,
  `payment_code` varchar(20) NOT NULL DEFAULT '',
  `out_trade_sn` varchar(20) NOT NULL DEFAULT '',
  `pay_time` int(10) unsigned DEFAULT NULL,
  `pay_message` varchar(255) NOT NULL DEFAULT '',
  `ship_time` int(10) unsigned DEFAULT NULL,
  `invoice_no` varchar(255) DEFAULT NULL,
  `finished_time` int(10) unsigned NOT NULL DEFAULT '0',
  `goods_amount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  `discount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  `order_amount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  `evaluation_status` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `evaluation_time` int(10) unsigned NOT NULL DEFAULT '0',
  `anonymous` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `postscript` varchar(255) NOT NULL DEFAULT '',
  `pay_alter` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`order_id`),
  KEY `order_sn` (`order_sn`,`seller_id`),
  KEY `seller_name` (`seller_name`),
  KEY `buyer_name` (`buyer_name`),
  KEY `add_time` (`add_time`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8");
E_D("replace into `ecm_order` values('1','0921861930','material','normal','2','演示店铺','3','buyer','buyer@ecmall.com','0','1249611845','2','银行汇款','bank','',NULL,'已付款100元',NULL,NULL,'0','170.00','0.00','175.00','0','0','0','','0');");
E_D("replace into `ecm_order` values('2','0921820055','material','normal','2','演示店铺','3','buyer','buyer@ecmall.com','40','1249611887','1','货到付款','cod','','1249612115','','1249612111','33333333','1249612115','170.00','0.00','180.00','1','1249612248','0','请尽快发货','0');");
E_D("replace into `ecm_order` values('3','0921801993','material','normal','2','演示店铺','3','buyer','buyer@ecmall.com','40','1249611902','2','银行汇款','bank','','1249612096','我已汇款','1249612102','cccc3333','1249612221','170.00','0.00','190.00','1','1249612230','0','','0');");
E_D("replace into `ecm_order` values('4','0921847484','material','normal','2','演示店铺','3','buyer','buyer@ecmall.com','40','1249611932','2','银行汇款','bank','','1249612086','已付款','1249612092','dddd2222','1249612205','129.00','0.00','134.00','1','1249612217','0','','0');");
E_D("replace into `ecm_order` values('5','0921838115','material','normal','2','演示店铺','3','buyer','buyer@ecmall.com','40','1249611951','1','货到付款','cod','','1249612081','','1249612077','dddd2222','1249612081','170.00','0.00','180.00','1','1249612201','0','','0');");
E_D("replace into `ecm_order` values('6','0921877812','material','normal','2','演示店铺','3','buyer','buyer@ecmall.com','40','1249611968','2','银行汇款','bank','','1249612054','已付款','1249612058','aaaaa','1249612171','169.00','0.00','174.00','1','1249612188','0','','0');");
E_D("replace into `ecm_order` values('7','0921848095','material','normal','2','演示店铺','3','buyer','buyer@ecmall.com','40','1249611987','1','货到付款','cod','','1249612050','','1249612042','abcd1234','1249612050','89.00','0.00','99.00','1','1249612167','0','','0');");
E_D("replace into `ecm_order` values('8','0921855800','material','normal','2','演示店铺','3','buyer','buyer@ecmall.com','40','1249611999','2','银行汇款','bank','','1249612021','已付款','1249612031','abcd1234','1249612132','188.00','0.00','208.00','1','1249612152','0','','0');");
E_D("replace into `ecm_order` values('9','1312189880','material','normal','8','时尚内衣秀','15','263124070','263124070@qq.com','0','1367480927','3','银行汇款','bank','',NULL,'xxxxxxxx',NULL,NULL,'0','76.00','0.00','96.00','0','0','0','','0');");
E_D("replace into `ecm_order` values('10','1312557758','material','normal','8','时尚内衣秀','1','admin','263124070@qq.com','0','1367821555','3','银行汇款','bank','',NULL,'6222021102007623231',NULL,NULL,'0','99.00','0.00','119.00','0','0','0','','0');");
E_D("replace into `ecm_order` values('11','1313299436','material','normal','8','时尚内衣秀','42','gonghang','romafans@163.com','0','1368428196','31','财付通中介担保','tenpay','1313284717',NULL,'',NULL,NULL,'0','99.00','0.00','99.00','0','0','0','快点发红','0');");
E_D("replace into `ecm_order` values('12','1313957024','material','normal','32','吉美嫁艺','10','123','2802759280@qq.com','11','1369011695','21','支付宝','alipay','1313957024',NULL,'',NULL,NULL,'0','980.00','0.00','986.00','0','0','0','','0');");
E_D("replace into `ecm_order` values('13','1313996451','material','normal','36','三娘精品婚纱礼服','10','123','2802759280@qq.com','11','1369029489','27','支付宝','alipay','1313996451',NULL,'',NULL,NULL,'0','368.00','0.00','374.00','0','0','0','','0');");
E_D("replace into `ecm_order` values('14','1314044171','material','normal','32','吉美嫁艺','10','123','2802759280@qq.com','11','1369096860','21','支付宝','alipay','1314044171',NULL,'',NULL,NULL,'0','980.00','0.00','986.00','0','0','0','','0');");
E_D("replace into `ecm_order` values('15','1314095712','material','normal','41','赛琪服饰','10','123','2802759280@qq.com','11','1369145942','32','支付宝','alipay','1314095712',NULL,'',NULL,NULL,'0','89.00','0.00','95.00','0','0','0','','0');");
E_D("replace into `ecm_order` values('16','1315009964','material','normal','24','花开的声音102','10','123','2802759280@qq.com','11','1370057359',NULL,NULL,'','',NULL,'',NULL,NULL,'0','181.00','0.00','187.00','0','0','0','','0');");
E_D("replace into `ecm_order` values('17','1315091722','material','normal','51','公主嫁衣婚纱礼服','10','123','2802759280@qq.com','11','1370057411',NULL,NULL,'','',NULL,'',NULL,NULL,'0','208.00','0.00','214.00','0','0','0','','0');");
E_D("replace into `ecm_order` values('18','1315014948','material','normal','24','花开的声音102','10','123','2802759280@qq.com','11','1370057482',NULL,NULL,'','',NULL,'',NULL,NULL,'0','181.00','0.00','187.00','0','0','0','','0');");
E_D("replace into `ecm_order` values('19','1315077160','material','normal','29','忆红妆婚纱礼服','10','123','2802759280@qq.com','11','1370057546',NULL,NULL,'','',NULL,'',NULL,NULL,'0','248.00','0.00','254.00','0','0','0','','0');");

require("../../inc/footer.php");
?>